TABLE_(USERS_001)
	INT_     (USERID) PRIMARY_KEY        // See Sequences_001
	STRING_  (USERS_TBL, 255)
	STRING_  (USERNAME, 255) // From GetEnv("USERNAME")
	STRING_  (DEFAULTSONGS_TBL, 255)
	STRING_  (RAWSONGS_TBL, 255)
	STRING_  (KEEPSONGS_TBL, 255)
	STRING_  (DEFAULTMACHINES_TBL, 255)
	STRING_  (DEFAULTMACHINENAME, 255)
	STRING_  (DEFAULTLISTS_TBL, 255)
	INT_     (DEFAULTLISTID)
	STRING_  (COMMENTS, 1024)
	INT_     (COUNT) // Throw this on there, not really in table
END_TABLE

TABLE_(LISTS_001)
	INT_     (LISTID) PRIMARY_KEY        // See Sequences_001
	STRING_  (LISTS_TBL, 255)
	STRING_  (LISTNAME, 255)
	STRING   (COMMENTS, 1024)
END_TABLE

TABLE_(SONGS_001)
	INT_    (SONGID) PRIMARY_KEY        // See Sequences_001
	STRING_ (SONGS_TBL, 255)
	STRING_	(TITLE, 255)
	STRING_	(NETWORKS_TBL, 255)
	STRING_	(NETWORKNAME, 255)
	STRING_	(MACHINES_TBL, 255)
	STRING_	(MACHINENAME, 255)
	STRING_	(DRIVENAME, 255)
	STRING_	(FOLDERNAME, 255)
	STRING_	(FILENAME, 512)
	STRING_	(ORIGINALFILENAME, 512)
	STRING_	(FILEPATH, 1024)
	STRING_	(ARTISTNAME, 255)
	STRING_ (PUBLISHERNAME, 255)
	STRING_ (COMPOSERNAME, 255)
	STRING_	(ALBUMNAME, 255)
	STRING_	(GENRENAME, 255)
	STRING_	(RELEASEYEAR, 5) // "YEAR" is a reserved word in PostgreSQL
	STRING_	(LISTSSONGISON_COLL, 255)
	INT_	(TRACKNO)
	INT_	(RATING)
	INT_	(LENGTHMS)
	INT_	(ORIGINALLENGTHMS)
	INT_	(FILESIZE)
	INT_	(ORIGINALFILESIZE)
	INT_	(SKIPINMS)
	INT_	(TRIMOFFENDMS)
	INT_	(PLAYMS)
	INT_	(SKIPMS)
	INT_	(STARTCT)
	INT_	(ROLLINCT)
	INT_	(SKIPCT)
	INT_	(REPEATCT)
	INT_	(FINISHCT)
	INT_	(SELECTCT)
	INT_	(ROLLINDEPTHSUM)
	TIME_   (WHENADDEDTODATABASE)				// Losing Timestamp portion
	TIME_   (WHENLASTMODIFIED)
	STRING_ (ISURL, 1)
	STRING_ (ISUNCPATH, 1)
	STRING_ (ISKEEPER, 1)
	STRING	(COMMENTS, 1024)
	INT_     (BITRATE)
	INT_     (SAMPLERATE)
	INT_     (CHANNELS)
	STRING_  (LYRICS, 1024)
	STRING_  (LANGUAGE, 10)
	STRING_  (FILEID, 128)    // NTFS FILE_ID_DESCRIPTOR  (http://msdn.microsoft.com/en-us/library/aa364227(VS.85).aspx)
	STRING_  (INPLAYLIST, 1)  // Indicator that songid found in list_songs_001, so colorize row
END_TABLE

TABLE_(SONGS_TEST)
	INT    (SONGID) PRIMARY_KEY        // See Sequences_001
	STRING (SONGS_TBL, 255)
	STRING	(TITLE, 255)
	STRING	(NETWORKS_TBL, 255)
	STRING	(NETWORKNAME, 255)
	STRING	(MACHINES_TBL, 255)
	STRING	(MACHINENAME, 255)
	STRING	(DRIVENAME, 255)
	STRING	(FOLDERNAME, 255)
	STRING	(FILENAME, 512)
	STRING	(ORIGINALFILENAME, 512)
	STRING	(FILEPATH, 1024)
	STRING	(ARTISTNAME, 255)
	STRING  (PUBLISHERNAME, 255)
	STRING  (COMPOSERNAME, 255)
	STRING	(ALBUMNAME, 255)
	STRING	(GENRENAME, 255)
	STRING	(RELEASEYEAR, 5)
	STRING	(LISTSSONGISON_COLL, 255)
	INT	(TRACKNO)
	INT	(RATING)
	INT	(LENGTHMS)
	INT	(ORIGINALLENGTHMS)
	INT	(FILESIZE)
	INT	(ORIGINALFILESIZE)
	INT	(SKIPINMS)
	INT	(TRIMOFFENDMS)
	INT	(PLAYMS)
	INT	(SKIPMS)
	INT	(STARTCT)
	INT	(ROLLINCT)
	INT	(SKIPCT)
	INT	(REPEATCT)
	INT	(FINISHCT)
	INT	(SELECTCT)
	INT	(ROLLINDEPTHSUM)
	DATE   (WHENADDED)				// Losing Timestamp portion
	STRING (ISURL, 1)
	STRING (ISUNCPATH, 1)
	STRING (ISKEEPER, 1)
	STRING	(COMMENTS, 1024)
	INT     (BITRATE)
	INT     (SAMPLERATE)
	INT     (CHANNELS)
	STRING  (LYRICS, 1024)
	STRING  (LANGUAGE, 10)
	STRING  (FILEID, 128)    // NTFS FILE_ID_DESCRIPTOR  (http://msdn.microsoft.com/en-us/library/aa364227(VS.85).aspx)
END_TABLE

TABLE_(LIST_SONGS_001)
    STRING_ (LISTSONGS_TBL, 255)
    INT	   (LISTID)
    STRING (LISTS_TBL, 255)
    STRING (LISTNAME, 255)
	INT    (SONGID)
	STRING (SONGS_TBL, 255)
	STRING	(TITLE, 255)
	STRING	(NETWORKS_TBL, 255)
	STRING	(NETWORKNAME, 255)
	STRING	(MACHINES_TBL, 255)
	STRING	(MACHINENAME, 255)
	STRING	(DRIVENAME, 255)
	STRING	(FOLDERNAME, 255)
	STRING	(FILENAME, 512)
	STRING	(FILEPATH, 1024)
	STRING  (USERS_TBL, 255)
	STRING  (USERNAME, 255)
	STRING	(ARTISTNAME, 255)
	STRING  (PUBLISHERNAME, 255)
	STRING  (COMPOSERNAME, 255)
	STRING	(ALBUMNAME, 255)
	DOUBLE_ (PROCESSORDER)
	DATE   (WHENADDED)				// Losing Timestamp portion
	STRING (ISURL, 1)
	STRING (ISUNCPATH, 1)
	STRING	(COMMENTS, 1024)
END_TABLE

TABLE_(SEQUENCES_001)
  STRING_ (TABLENAME, 255)
  INT_ (NEXTID)
END_TABLE

TABLE_(SONGS_WORKQUEUE_001)
  INT (SONGID)
  STRING (SONGS_TBL, 255)
  STRING_ (LOOKTOSONGS_TBL, 255)
  INT_ (WORKTYPEID)
  DATE_ (WHENCOMPLETED)
  STRING_ (ISCOMPLETE, 1)
  STRING_ (ISERROR, 1)
  STRING_ (ISBEINGWORKEDON, 1)
  STRING_ (OUTCOME, 255)
END_TABLE

TABLE_(FOLDERS_001)
	STRING	(MACHINENAME, 255)
	STRING_	(FOLDERPATH, 255)
	TIME_	(WHENLASTREAD)
	STRING	(COMMENTS, 1024)
END_TABLE

